FaDlDisb

Logical Entity Name | FaDlDisb
Default Table Name | FaDlDisb
Physical Only | NO
Owner | dbo
Definition |
Note |

FaDlDisb Columns

ColumnName | Domain | Datatype | NULL | Definition
FaDlDisbId |  | int | NO |
faloanid |  | int | NO |
fastudentaidid |  | int | NO |
satransid |  | int | NO |
farefundid |  | int | YES |
disbnum |  | int | YES |
disbtype |  | char(1) | YES |
transactiondate |  | datetime | YES |
disbsequencenum |  | int | YES |
disbgrossamount |  | money | YES |
disbfeeamount |  | money | YES |
disbnetamount |  | money | YES |
disbnetadjust |  | money | YES |
origdisbdate |  | datetime | YES |
exportbatchid |  | varchar(30) | YES |
exportdate |  | datetime | YES |
acknowledgedate |  | datetime | YES |
disbstatus |  | char(1) | YES |
schoolcodestatus |  | char(1) | YES |
loanidstatus |  | char(1) | YES |
disbnumstatus |  | char(1) | YES |
disbactivitycodes |  | char(10) | YES |
transactiondatestatus |  | char(1) | YES |
sequencenumstatus |  | char(1) | YES |
locdisbgrossamount |  | money | YES |
locdisbfeeamount |  | money | YES |
locdisbnetamount |  | money | YES |
locnetadjust |  | money | YES |
bookstatus |  | char(1) | YES |
loctotalnetamount |  | money | YES |
affirmationflag |  | char(1) | YES |
loandetailbatchid |  | char(23) | YES |
userid |  | int | NO |
dateadded |  | datetime | NO |
datelstmod |  | datetime | NO |
ts |  | timestamp | NO |
BookDate |  | datetime | YES |
DisbRebateAmount |  | money | YES |
FirstActualDisbursement |  | bit | YES |
LocDisbRebateAmount |  | numeric(18, 0) | YES |
ServicerRefundAmount |  | numeric(18, 0) | YES |
FaSchedID |  | int | YES |
PrevDisbSequenceNum |  | int | YES |
CODCommentCodes |  | varchar(100) | YES |
PublishedPgmLengthValue |  | numeric(7, 3) | YES |
PublishedPgmLengthType |  | char(1) | YES |
ProgramCipCode2 |  | nvarchar(7) | YES |
ProgramCipCode3 |  | nvarchar(7) | YES |
EnrollmentStatus |  | char(1) | YES |
ProgramCipCode |  | varchar(7) | YES |
PaymentPeriodStartDate |  | datetime | YES |
ProgramCredentialLevel |  | varchar(2) | YES |
PublishedPgmLengthYears |  | numeric(7, 3) | YES |
PublishedPgmLengthMonths |  | numeric(7, 3) | YES |
PublishedPgmLengthWeeks |  | numeric(7, 3) | YES |
SpecialPrograms |  | char(1) | YES |
WeeksProgramsAcademicYear |  | numeric(7, 2) | YES |
PaymentPeriodEndDate |  | datetime | YES |

FaDlDisb Primary and Unique Keys

Key Name | Key Type | Keys
FaDlDisb_FaDlDisbID_U_C_IDX | PrimaryKey | FaDlDisbId

FaDlDisb Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

FaDlDisb Check Constraints

Check Constraint Name | CheckConstraint

FaDlDisb Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

FaDlDisb Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.DirectLoanDisbursement | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaDlDisb | NO |  |  |

FaDlDisb Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaDlDisb Data Movement Rules

Name | Type | Rule Text/Value